-- ----------------------------
-- Table structure for customer
-- ----------------------------
drop table customer;
create table customer(
  id int primary key,
  create_time timestamp default localtimestamp,
  username varchar2(15) not null,
  password varchar2(20) not null,
  age number(3) not null
);

-- ----------------------------
-- Sequence for id of the table customer
-- ----------------------------
drop sequence customer_id_seq;
create sequence customer_id_seq
minvalue 0
maxvalue 99999999
increment by 1
start with 1
cache 10
order;

-- ----------------------------
-- Init data for customer
-- ----------------------------
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer0', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer1', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer2', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer3', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer4', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer5', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer6', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer7', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer8', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer9', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer10', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer11', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer12', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer13', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer14', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer15', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer16', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer17', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer18', '123456', 10);
insert into customer(id, username, password, age) values(customer_id_seq.nextval, 'customer19', '123456', 10);

commit;
